Batch Update Values
AutomatR.GoogleSheets.Activities.BatchUpdateValues
The "Batch Update Values" activity in AutomatR for Google Sheets enables users to send a single batch update that includes values from multiple Google Sheet activities. It provides a convenient way to make multiple changes to a single spreadsheet within a specified sheet.
Properties
| Name | Description |
|---|---|
| Input | |
| Sheet Name | Specifies the name of the sheet within the Google spreadsheet where values will be updated. String variables containing the desired sheet name. |
| Spreadsheet File Name | If not already existent, specifies the spreadsheet file to open or create. String variables containing the spreadsheet file name. |
| Batch Update Scope | Represents the file ID opened or created by the activity. Input argument of type SheetsService to carry the batch update scope. |
| Miscellaneous | |
| Display Name | Provides a customizable name for the activity displayed in the workflow. The display name enhances clarity and organization within the automation project. String variables containing the desired display name. |
| Optional | |
| Delay | Specifies the amount of time (in seconds) to wait before executing the "Batch Update Values" activity. This can be useful for handling synchronization issues. Integer variables containing the delay duration. Example: If the amount of time is 1000 milliseconds or 1 sec, i.e., 1. |
The "Batch Update Values" activity does not have specific output properties. However, it can provide an overall result of the batch update process through a visual representation of successful execution or encountered errors within the workflow.
How to Use
- Drag and drop the "Batch Update Values" activity onto the workflow.
- Configure the properties by specifying the sheet name, spreadsheet file name, and batch update scope.
- Optionally, configure the delay and customize the display name.
- Add multiple Google Sheet activities inside the "Batch Update Values" activity to include them in the batch update process.
- Execute the workflow to perform a batch update of values in the specified sheet of the Google spreadsheet.
Example
Consider an example where the "Batch Update Values" activity is used to update values in the "Expenses" sheet of a Google spreadsheet:
Batch Update Values:
Display Name: "Update Expenses"
Sheet Name: "Expenses"
Spreadsheet File Name: "MyExpenseSheet"
Batch Update Scope: GoogleSheetsService
Delay: 2
In this example, the activity updates values in the "Expenses" sheet of the "MyExpenseSheet" Google spreadsheet. The delay is set to 2 seconds to allow for proper synchronization. Additional Google Sheet activities can be added inside the "Batch Update Values" scope to include them in the batch update process.